/*
 Navicat Premium Data Transfer

 Source Server         : demo
 Source Server Type    : MySQL
 Source Server Version : 80031
 Source Host           : localhost:3306
 Source Schema         : 02-15-monthB

 Target Server Type    : MySQL
 Target Server Version : 80031
 File Encoding         : 65001

 Date: 07/07/2023 17:11:24
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for house
-- ----------------------------
DROP TABLE IF EXISTS `house`;
CREATE TABLE `house` (
  `id` int NOT NULL AUTO_INCREMENT,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '楼盘名称',
  `address` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '楼盘地址',
  `province_id` int DEFAULT NULL COMMENT '省id',
  `city_id` int DEFAULT NULL COMMENT '市id',
  `pic_url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '图片地址',
  `area` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '建筑面积',
  `sms` int DEFAULT NULL COMMENT '是否已发送短信  0否 1是',
  `qu` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `idx_region` (`province_id`,`city_id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=15 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- ----------------------------
-- Records of house
-- ----------------------------
BEGIN;
INSERT INTO `house` (`id`, `name`, `address`, `province_id`, `city_id`, `pic_url`, `area`, `sms`, `qu`) VALUES (1, '碧桂园小区', '和平路1号', 1, 4, NULL, '1000', NULL, NULL);
INSERT INTO `house` (`id`, `name`, `address`, `province_id`, `city_id`, `pic_url`, `area`, `sms`, `qu`) VALUES (2, '保利小区', '健康路1号', 2, 9, NULL, '2000', NULL, NULL);
INSERT INTO `house` (`id`, `name`, `address`, `province_id`, `city_id`, `pic_url`, `area`, `sms`, `qu`) VALUES (3, '融创小区', '胜利路1号', 3, 13, NULL, '3000', NULL, NULL);
INSERT INTO `house` (`id`, `name`, `address`, `province_id`, `city_id`, `pic_url`, `area`, `sms`, `qu`) VALUES (4, '绿地小区', '建国路1号', 3, 14, NULL, '3500', NULL, NULL);
INSERT INTO `house` (`id`, `name`, `address`, `province_id`, `city_id`, `pic_url`, `area`, `sms`, `qu`) VALUES (5, '绿地小区3区', '建国路1号', 3, 15, NULL, '3500', NULL, NULL);
INSERT INTO `house` (`id`, `name`, `address`, `province_id`, `city_id`, `pic_url`, `area`, `sms`, `qu`) VALUES (6, '绿地小区2区', '建国路1号', 3, 15, NULL, '3500', NULL, NULL);
INSERT INTO `house` (`id`, `name`, `address`, `province_id`, `city_id`, `pic_url`, `area`, `sms`, `qu`) VALUES (7, '绿地小区4区', '建国路1号', 3, 16, NULL, '3500', NULL, NULL);
INSERT INTO `house` (`id`, `name`, `address`, `province_id`, `city_id`, `pic_url`, `area`, `sms`, `qu`) VALUES (8, '绿地小区5区', '建国路1号', 3, 16, NULL, '3500', NULL, NULL);
INSERT INTO `house` (`id`, `name`, `address`, `province_id`, `city_id`, `pic_url`, `area`, `sms`, `qu`) VALUES (9, '绿地小区6区', '建国路1号', 3, 17, NULL, '3500', NULL, NULL);
INSERT INTO `house` (`id`, `name`, `address`, `province_id`, `city_id`, `pic_url`, `area`, `sms`, `qu`) VALUES (10, '万达小区1号', '晋城高平市', 3, 17, 'http://localhost:8080/static/1672124638925saber02.jpeg', '200', NULL, NULL);
INSERT INTO `house` (`id`, `name`, `address`, `province_id`, `city_id`, `pic_url`, `area`, `sms`, `qu`) VALUES (11, 'dddd', 'ddddd', 1, 4, 'http://localhost:8080/static/1672195230428saber02.jpeg', '200', NULL, NULL);
INSERT INTO `house` (`id`, `name`, `address`, `province_id`, `city_id`, `pic_url`, `area`, `sms`, `qu`) VALUES (12, '123456', '123456', 1, 4, 'http://localhost:8080/static/1676433494853kung.png', NULL, NULL, NULL);
INSERT INTO `house` (`id`, `name`, `address`, `province_id`, `city_id`, `pic_url`, `area`, `sms`, `qu`) VALUES (13, '45678', '45678', 2, 10, 'http://localhost:8080/static/1676433845438kung.png', NULL, NULL, NULL);
INSERT INTO `house` (`id`, `name`, `address`, `province_id`, `city_id`, `pic_url`, `area`, `sms`, `qu`) VALUES (14, 'efsfdsfds', NULL, 1, 4, 'http://localhost:8080/static/cc552867-dbae-4936-9af5-253ad14d048dtest01.jpg', NULL, NULL, NULL);
COMMIT;

-- ----------------------------
-- Table structure for people_education
-- ----------------------------
DROP TABLE IF EXISTS `people_education`;
CREATE TABLE `people_education` (
  `id` int NOT NULL AUTO_INCREMENT,
  `name` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb3;

-- ----------------------------
-- Records of people_education
-- ----------------------------
BEGIN;
INSERT INTO `people_education` (`id`, `name`) VALUES (1, '初中');
INSERT INTO `people_education` (`id`, `name`) VALUES (2, '高中');
INSERT INTO `people_education` (`id`, `name`) VALUES (3, '中专');
INSERT INTO `people_education` (`id`, `name`) VALUES (4, '大专');
INSERT INTO `people_education` (`id`, `name`) VALUES (5, '硕士');
COMMIT;

-- ----------------------------
-- Table structure for people_manage
-- ----------------------------
DROP TABLE IF EXISTS `people_manage`;
CREATE TABLE `people_manage` (
  `id` int NOT NULL AUTO_INCREMENT,
  `name` varchar(255) DEFAULT NULL,
  `phone` varchar(255) DEFAULT NULL,
  `post_id` int DEFAULT NULL COMMENT '岗位id',
  `source_id` int DEFAULT NULL COMMENT '信息来源id',
  `result` varchar(255) DEFAULT NULL COMMENT '面试反馈',
  `status` int DEFAULT NULL COMMENT '人员状态',
  `education_id` int DEFAULT NULL,
  `school` varchar(255) DEFAULT NULL,
  `email` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `uk_tttt` (`post_id`,`source_id`,`status`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8mb3;

-- ----------------------------
-- Records of people_manage
-- ----------------------------
BEGIN;
INSERT INTO `people_manage` (`id`, `name`, `phone`, `post_id`, `source_id`, `result`, `status`, `education_id`, `school`, `email`) VALUES (1, '乔代曼', '15263921536', 1, 1, '未通过', 1, 1, NULL, NULL);
INSERT INTO `people_manage` (`id`, `name`, `phone`, `post_id`, `source_id`, `result`, `status`, `education_id`, `school`, `email`) VALUES (2, '张三', '15263921536', 1, 2, '第二轮', 1, 2, NULL, NULL);
INSERT INTO `people_manage` (`id`, `name`, `phone`, `post_id`, `source_id`, `result`, `status`, `education_id`, `school`, `email`) VALUES (3, '李四', '1526392346', 1, 3, '第3轮', 1, 3, NULL, NULL);
INSERT INTO `people_manage` (`id`, `name`, `phone`, `post_id`, `source_id`, `result`, `status`, `education_id`, `school`, `email`) VALUES (4, '王五', '15263921546', 1, 2, '通过', 2, 4, NULL, NULL);
INSERT INTO `people_manage` (`id`, `name`, `phone`, `post_id`, `source_id`, `result`, `status`, `education_id`, `school`, `email`) VALUES (5, 'tom', '15263921556', 2, 1, '通过', 1, 5, NULL, NULL);
INSERT INTO `people_manage` (`id`, `name`, `phone`, `post_id`, `source_id`, `result`, `status`, `education_id`, `school`, `email`) VALUES (6, 'jerry', '1526391234', 2, 2, '通过', 3, 1, NULL, NULL);
INSERT INTO `people_manage` (`id`, `name`, `phone`, `post_id`, `source_id`, `result`, `status`, `education_id`, `school`, `email`) VALUES (7, 'jerry', '1526391234', 3, 1, '通过', 1, 1, NULL, NULL);
INSERT INTO `people_manage` (`id`, `name`, `phone`, `post_id`, `source_id`, `result`, `status`, `education_id`, `school`, `email`) VALUES (8, 'jerry', '1526391234', 3, 2, '通过', 3, 2, NULL, NULL);
INSERT INTO `people_manage` (`id`, `name`, `phone`, `post_id`, `source_id`, `result`, `status`, `education_id`, `school`, `email`) VALUES (9, 'jerry', '1526391234', 3, 2, '通过', 3, 2, NULL, NULL);
INSERT INTO `people_manage` (`id`, `name`, `phone`, `post_id`, `source_id`, `result`, `status`, `education_id`, `school`, `email`) VALUES (10, 'cc hu', '17611221735', 1, 1, NULL, NULL, 1, NULL, '751283482@qq.com');
INSERT INTO `people_manage` (`id`, `name`, `phone`, `post_id`, `source_id`, `result`, `status`, `education_id`, `school`, `email`) VALUES (11, 'cc hu', '17611221735', 1, 1, NULL, NULL, 1, NULL, '751283482@qq.com');
COMMIT;

-- ----------------------------
-- Table structure for people_post
-- ----------------------------
DROP TABLE IF EXISTS `people_post`;
CREATE TABLE `people_post` (
  `id` int NOT NULL AUTO_INCREMENT,
  `name` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb3;

-- ----------------------------
-- Records of people_post
-- ----------------------------
BEGIN;
INSERT INTO `people_post` (`id`, `name`) VALUES (1, '开发');
INSERT INTO `people_post` (`id`, `name`) VALUES (2, '测试');
INSERT INTO `people_post` (`id`, `name`) VALUES (3, '运维');
INSERT INTO `people_post` (`id`, `name`) VALUES (4, '运营');
COMMIT;

-- ----------------------------
-- Table structure for people_source
-- ----------------------------
DROP TABLE IF EXISTS `people_source`;
CREATE TABLE `people_source` (
  `id` int NOT NULL AUTO_INCREMENT,
  `name` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb3;

-- ----------------------------
-- Records of people_source
-- ----------------------------
BEGIN;
INSERT INTO `people_source` (`id`, `name`) VALUES (1, 'Boss直聘');
INSERT INTO `people_source` (`id`, `name`) VALUES (2, '猎聘');
INSERT INTO `people_source` (`id`, `name`) VALUES (3, '拉勾');
INSERT INTO `people_source` (`id`, `name`) VALUES (4, '内推');
COMMIT;

-- ----------------------------
-- Table structure for people_status
-- ----------------------------
DROP TABLE IF EXISTS `people_status`;
CREATE TABLE `people_status` (
  `id` int NOT NULL AUTO_INCREMENT,
  `name` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb3;

-- ----------------------------
-- Records of people_status
-- ----------------------------
BEGIN;
INSERT INTO `people_status` (`id`, `name`) VALUES (1, '面试中');
INSERT INTO `people_status` (`id`, `name`) VALUES (2, '已入职');
INSERT INTO `people_status` (`id`, `name`) VALUES (3, '已离职');
COMMIT;

-- ----------------------------
-- Table structure for region
-- ----------------------------
DROP TABLE IF EXISTS `region`;
CREATE TABLE `region` (
  `id` int NOT NULL AUTO_INCREMENT,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '名称',
  `parent_id` int DEFAULT NULL COMMENT '父级id',
  `level` int DEFAULT NULL COMMENT '0 代表省,  1代表市',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=19 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- ----------------------------
-- Records of region
-- ----------------------------
BEGIN;
INSERT INTO `region` (`id`, `name`, `parent_id`, `level`) VALUES (1, '河北省', NULL, 0);
INSERT INTO `region` (`id`, `name`, `parent_id`, `level`) VALUES (2, '山东省', NULL, 0);
INSERT INTO `region` (`id`, `name`, `parent_id`, `level`) VALUES (3, '山西省', NULL, 0);
INSERT INTO `region` (`id`, `name`, `parent_id`, `level`) VALUES (4, '廊坊市', 1, 1);
INSERT INTO `region` (`id`, `name`, `parent_id`, `level`) VALUES (5, '邢台市', 1, 1);
INSERT INTO `region` (`id`, `name`, `parent_id`, `level`) VALUES (6, '唐山市', 1, 1);
INSERT INTO `region` (`id`, `name`, `parent_id`, `level`) VALUES (7, '石家庄市', 1, 1);
INSERT INTO `region` (`id`, `name`, `parent_id`, `level`) VALUES (8, '邯郸市', 1, 1);
INSERT INTO `region` (`id`, `name`, `parent_id`, `level`) VALUES (9, '济南市', 2, 1);
INSERT INTO `region` (`id`, `name`, `parent_id`, `level`) VALUES (10, '潍坊市', 2, 1);
INSERT INTO `region` (`id`, `name`, `parent_id`, `level`) VALUES (11, '青岛市', 2, 1);
INSERT INTO `region` (`id`, `name`, `parent_id`, `level`) VALUES (12, '菏泽市', 2, 1);
INSERT INTO `region` (`id`, `name`, `parent_id`, `level`) VALUES (13, '太原市', 3, 1);
INSERT INTO `region` (`id`, `name`, `parent_id`, `level`) VALUES (14, '阳泉市', 3, 1);
INSERT INTO `region` (`id`, `name`, `parent_id`, `level`) VALUES (15, '吕梁市', 3, 1);
INSERT INTO `region` (`id`, `name`, `parent_id`, `level`) VALUES (16, '大同市', 3, 1);
INSERT INTO `region` (`id`, `name`, `parent_id`, `level`) VALUES (17, '晋城市', 3, 1);
INSERT INTO `region` (`id`, `name`, `parent_id`, `level`) VALUES (18, '南城区', 17, 2);
COMMIT;

-- ----------------------------
-- Table structure for user_info
-- ----------------------------
DROP TABLE IF EXISTS `user_info`;
CREATE TABLE `user_info` (
  `id` int NOT NULL AUTO_INCREMENT,
  `phone` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `password` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `salt` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '用户名,gitee仓库空间名',
  `nick_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT 'gitee的昵称',
  `avatar_url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT 'gitee的头像',
  `gitee_id` int DEFAULT NULL COMMENT 'gitee的id',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- ----------------------------
-- Records of user_info
-- ----------------------------
BEGIN;
INSERT INTO `user_info` (`id`, `phone`, `password`, `salt`, `name`, `nick_name`, `avatar_url`, `gitee_id`) VALUES (3, '17611221735', '965cb00439a8e2d8bf3522723c85189c', 'ce1c1fd1', NULL, 'Aikun', 'https://foruda.gitee.com/avatar/1688375543562089385/12065236_hccxx_1688375543.png', 12065236);
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
